Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Post Code' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to POST CODE

Seq No	Page Number	Page Name	Control Name
1	1	Company Information	Post Code
2	1	Company Information	Post Code
3	21	Customer Card	Post Code
4	22	Customer List	Post Code
5	26	Vendor Card	Post Code
6	27	Vendor List	Post Code
7	33	Customer Lookup	Post Code
8	34	Vendor Lookup	Post Code
9	76	Resource Card	Post Code
10	300	Ship-to Address	Post Code
11	300	Ship-to Address	Post Code
12	301	Ship-to Address List	Post Code
13	368	Order Address	Post Code
14	368	Order Address	Post Code
15	369	Order Address List	Post Code
16	370	Bank Account Card	Post Code
17	371	Bank Account List	Post Code
18	423	Customer Bank Account Card	Post Code
19	424	Customer Bank Account List	Post Code
20	425	Vendor Bank Account Card	Post Code
21	426	Vendor Bank Account List	Post Code
22	434	Reminder	Post Code
23	436	Reminder List	Post Code
24	438	Issued Reminder	Post Code
25	440	Issued Reminder List	Post Code
26	446	Finance Charge Memo	Post Code
27	448	Finance Charge Memo List	Post Code
28	450	Issued Finance Charge Memo	Post Code
29	452	Issued Fin. Charge Memo List	Post Code
30	1165	COHUB Enviroment Card	Post Code
31	1382	Customer Templ. Card	Post Code
32	1386	Vendor Templ. Card	Post Code
33	1388	Employee Templ. Card	Post Code
34	1803	Assisted Company Setup Wizard	Post Code
35	2148	O365 Address	Post Code
36	2318	BC O365 Sales Customer Card	Post Code
37	2330	BC O365 Business Info Settings	Post Code
38	2368	Remit Address	Post Code
39	2368	Remit Address	Post Code
40	2369	Remit Address List	Post Code
41	2379	BC O365 Contact Lookup	Post Code
42	5050	Contact Card	Post Code
43	5052	Contact List	Post Code
44	5054	Company Details	Post Code
45	5056	Contact Alt. Address Card	Post Code
46	5057	Contact Alt. Address List	Post Code
47	5200	Employee Card	Post Code
48	5201	Employee List	Post Code
49	5203	Alternative Address Card	Post Code
50	5204	Alternative Address List	Post Code
51	5213	Unions	Post Code
52	5703	Location Card	Post Code
53	5714	Responsibility Center Card	Post Code
54	5900	Service Order	Post Code
55	5933	Service Invoice	Post Code
56	5935	Service Credit Memo	Post Code
57	5964	Service Quote	Post Code
58	5971	Posted Service Credit Memos	Post Code
59	5972	Posted Service Credit Memo	Post Code
60	5974	Posted Service Shipments	Post Code
61	5975	Posted Service Shipment	Post Code
62	5977	Posted Service Invoices	Post Code
63	5978	Posted Service Invoice	Post Code
64	5980	Service Item Card	Post Code
65	6050	Service Contract	Post Code
66	6053	Service Contract Quote	Post Code
67	6072	Filed Service Contract	Post Code
68	8629	Config. Wizard	Post Code

Dynamics 365 BC Table ReferencePage Control Search